SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026453 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026453 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144340,56462,607413,68653,999565,606557,814712,368278,325725,133736,629393,92557,179399,276515,759935,338374,36149,220005,861098,183785,715229,240893,631783,1009475,468758,130245,149454,555647,846454,703967,226306,524878,829587,962039,191474,972573,251480,326810,998526,261910,102906,728353,153901,946379,767730,494740,630507,66321,183006,243428,124277,368484,127108,767891,435566,236100,68625,981755,224440,529268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]