SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471857 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471857 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505941,1032261,13804,307327,528498,453080,231091,460854,569760,615868,742599,785077,1008763,393845,820835,453340,870600,268578,812159,927559,985275,127672,974581,490159,1002696,333505,328585,422595,699149,980475,570686,59007,45527,70899,332866,200361,153298,713463,105175,369692,380014,142164,232979,371170,1047636,704074,102741,337594,624616,883432,534850,116776,235170,748900,10972,1012277,427234,310531,60552,790334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]