SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67498 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67498 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422682,243628,664636,7276,446495,23697,956944,608946,493050,126765,1008143,370336,371290,631617,33471,484895,862705,1007861,220351,619659,246787,495962,824045,837310,838467,653432,305005,1036737,510727,997020,666565,321813,265612,8636,673037,185269,554396,806337,991931,14652,376384,355166,488815,512278,755665,641664,520920,56258,1026854,34020,548265,496110,33780,752110,385709,149459,318941,612524,89234,569196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]