SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335862 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335862 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251258,828189,763072,766108,101641,606343,925041,669321,115333,7292,703880,254105,68637,530430,236690,21710,1013825,499992,111206,150370,608443,257065,762658,46033,736424,252093,874240,170812,262623,943282,152725,1005376,356393,38516,490011,396558,883052,94974,165607,714562,973502,298758,1011489,576508,395329,38592,195916,983905,310177,1021544,1005476,733656,837949,724883,883851,290804,395180,109580,188447,287409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]