SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036391 LIMIT 1 [ RunTime:0.003440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036391 [ RunTime:0.005254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771500,282389,296106,887498,261791,757133,317340,447624,622444,553753,261965,15687,729412,913962,398661,382570,183436,328618,602623,195917,593496,781556,649194,315577,289469,939979,1034391,858700,973350,229671,84086,325492,891321,1045226,977998,923439,328174,257683,918280,699721,589967,600664,693700,283277,388970,158078,406110,9834,97862,623271,617043,495348,677584,328455,1015167,725917,475671,339188,845376,917172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]