SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980020 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980020 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951985,440082,632427,272755,432741,112590,595626,526269,887503,614694,323257,373879,467959,915595,883774,98631,78917,722281,711041,672525,437688,125637,297809,480138,377357,449055,507641,290293,207305,962672,986231,992023,955917,754044,444946,33115,116610,952808,433583,869780,782252,175942,372206,428928,783073,229369,77975,779547,1003254,590157,176490,214152,531036,982299,352693,251042,917348,1014653,624654,947995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]