SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405845 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405845 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852994,637426,953367,145028,918614,762751,384577,418274,598013,495770,184513,321071,959814,86049,114480,285337,206897,951845,276632,416379,465106,145479,979470,712007,2273,231203,1001146,874550,70551,752598,812757,360760,298787,671435,884234,26355,440288,9720,302341,967071,417660,424706,12432,821504,727074,986055,906183,445770,411843,938151,371496,41298,393022,650530,431485,359681,115271,122660,46800,8645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]