SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512963 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512963 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552662,566907,786546,246985,8555,369594,455808,313732,471427,184697,1034216,522276,35436,901196,806900,858801,569889,674746,735708,574072,223107,494276,615225,883997,608706,588293,122765,907282,511396,370066,830960,685442,15292,315283,747341,130146,151067,819983,459995,1041840,853699,984586,544108,794720,598588,552448,234611,354921,1020289,758835,474055,1010894,610813,472715,561787,195893,587117,546469,906122,211329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]