SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473891 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473891 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489257,359790,994657,841970,977286,1031588,450226,633073,381053,550716,681903,470836,675352,424113,477795,405017,206093,796028,408305,207649,442582,879178,1026675,858914,579840,531653,451700,245980,459630,34401,358253,651103,380144,237593,1018728,282217,209125,790316,509901,499242,325174,736366,346974,56787,461852,697149,467650,9708,377502,953347,902538,411737,322824,182089,960313,1011949,702688,755091,472507,761772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]