SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588080 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588080 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65265,36379,521951,98364,886769,487618,169854,120096,622999,772669,596942,510983,232699,61468,276958,862439,98704,719599,547319,339653,373180,196496,312265,569728,367570,747486,925413,57952,278590,168616,402868,302393,167515,818500,816156,446143,99670,555214,100422,976048,449011,317003,637944,495604,745238,915706,929953,94781,1046669,570610,221098,1022532,1023711,191519,193938,1015543,72295,625371,381774,565162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]