SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195551 LIMIT 1 [ RunTime:0.001379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195551 [ RunTime:0.004383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687731,1033923,606333,146307,8321,962630,1001956,620770,693620,516231,810327,302113,147819,818436,951270,716086,288456,409261,443577,404480,300762,869934,339448,827636,879320,651119,463590,540739,316946,360004,767099,1041753,436559,19003,885670,759348,679041,382723,754233,562571,519111,387667,160118,87765,867313,901487,682876,546084,915449,685096,726613,345744,954728,933080,552722,943903,262776,120549,1009596,508716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]