SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501777 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501777 [ RunTime:0.003267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391037,63048,688616,277018,406967,659991,884719,576575,210174,208152,146271,186513,399687,660194,833302,790115,418754,972589,727042,316194,899014,514044,451364,485709,489998,208916,284137,451381,332077,778163,518514,689086,95552,10739,948972,840826,554387,325119,275665,648305,445560,246784,325746,663477,711154,835264,610501,252326,431460,70819,822434,1022829,314603,416348,828905,277881,562878,779247,352933,1027221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]