SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311753 LIMIT 1 [ RunTime:0.001310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311753 [ RunTime:0.006486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990013,986893,910061,299919,120871,826122,410024,428517,210047,905132,232026,235408,231006,664585,418113,201076,642248,366106,255237,971440,677701,272954,951568,111265,1012576,858517,1032801,37402,338949,730435,658533,803837,580909,329869,959064,939439,620896,276841,363019,967785,195529,607926,462135,750886,176050,696370,264153,1028781,621034,943728,119570,596609,460655,505788,947264,486460,371719,522357,968427,722136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001945s ]