SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340414 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340414 [ RunTime:0.004683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53119,841816,574315,464630,545162,384677,809954,84056,585120,866294,544460,105000,774968,576556,450174,637562,62357,865052,175796,377625,268557,454160,724236,568978,968917,851491,986044,868252,800058,185311,856285,963790,516218,832720,892839,860796,575581,377192,446628,422266,315531,160476,722821,138210,821209,636653,596074,659969,106908,807575,1033147,144266,1014245,172936,628721,1037035,146921,998039,627026,404182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003978s ]