SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196428 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196428 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520841,10903,895001,906051,409968,257898,395359,323287,868500,419330,1022984,371442,628420,147618,538765,806727,466375,33809,388335,483178,676229,98616,434348,327839,343162,754320,388375,743907,432345,501835,637884,575041,538110,82503,706552,157107,522998,696745,292282,289661,958813,786452,978303,119190,109540,585236,351189,456234,640458,24463,379272,972994,539136,357560,135405,42495,354818,892660,531438,511115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]