SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51661 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51661 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971913,299848,131956,962398,19737,839150,889363,544963,159915,572708,210182,792700,256674,100310,669893,739390,425217,125636,224618,1009485,583842,960625,1012362,653466,889462,582638,727298,382960,640366,968495,812358,481130,367780,322839,366311,606393,534113,912078,1040959,978614,458232,530572,505923,429446,297898,901734,242302,602643,165648,611348,1003145,967205,229602,982649,1019147,422663,297643,584550,337064,253760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]