SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432830 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432830 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509940,311638,257540,168632,218163,738028,289394,59711,384404,820734,486532,358381,700235,312693,890476,1029486,495096,463383,929500,161810,335970,162884,509178,1001010,762247,235111,878308,230940,538410,509763,582807,747202,815968,114573,823718,583457,30201,886660,631089,978103,406945,547529,965114,828428,408358,989799,161687,631711,694774,1047112,746180,913345,669445,887610,624824,718266,601307,571114,871076,613098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]