SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426650 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426650 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280189,389458,521030,205491,1039490,842417,431851,1038164,314410,348178,235471,52250,572846,48086,738681,876553,509390,340074,821258,553740,668579,806702,305202,630146,801043,438843,705871,710316,507286,23469,82352,760464,214201,833562,931216,859579,627420,504181,393153,475412,652974,150943,20117,587440,352345,336807,908684,989932,781712,197242,900325,138018,683218,938145,667418,4364,965247,735164,503221,20754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]