SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319042 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319042 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165871,910114,734179,591866,391789,765603,496058,39477,427166,563008,491843,1046024,180419,1027178,182918,709875,556105,502267,428611,829317,646976,439086,639383,821738,262706,783594,551417,916511,1006804,324956,422190,833350,82065,914538,12738,846187,67799,735415,95167,300777,30129,803179,337150,784418,519552,457236,101855,606500,617554,979545,107394,95879,866055,1009846,171670,358391,391783,249926,569634,872017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001026s ]