SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905026 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905026 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001880,379722,436686,981595,352422,680628,673299,903749,1048310,852030,353619,454436,46494,648833,1041893,520424,857505,435650,748677,499372,531819,166024,140511,677120,839659,136145,259097,999228,480304,63042,798630,748450,114941,280724,187420,261590,282512,672268,163508,741709,911681,935809,831562,556210,1040339,670867,969232,643322,107955,434967,73266,894700,56670,214275,920027,199458,809313,203277,890042,226037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]