SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484328 LIMIT 1 [ RunTime:0.001694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484328 [ RunTime:0.002951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522093,1045633,664094,1023633,861672,984860,304393,464829,274477,969627,963044,624271,689011,885548,381812,759536,430388,1035849,1026490,203094,905039,1036943,196232,1022187,588277,476774,1016959,1048901,580192,74220,744605,288009,181128,40980,1036519,713696,42236,377250,705159,590181,237964,54229,837611,957746,798634,201519,315377,54096,779117,740730,291148,562924,685527,814565,912554,825877,797697,484667,44488,592010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003943s ]