SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 741234 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 741234 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529869,1022454,269504,365843,40016,746629,280730,811979,824714,528087,282165,747744,288429,7935,174445,397156,808797,162021,634386,952440,49050,486058,197597,142489,633866,91895,671831,703716,327842,836973,72936,752654,916007,548667,451323,315958,96138,261006,1022617,954039,625424,899624,373106,983953,264465,975302,868464,380624,997611,463474,374897,1024458,64438,585526,923153,44142,448628,735193,702645,597159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 741234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 741234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002571s ]