SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418680 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418680 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154671,95025,766833,314,90266,130236,892512,675634,668273,905613,568515,655520,477312,947781,28992,402821,762342,46821,55854,330600,271689,366733,805167,543815,289345,335532,950555,313426,207995,315607,556931,203032,795951,571155,853746,162443,101289,546441,797395,704409,158863,946057,915666,931055,811869,383007,180516,934909,512841,145419,457522,630137,676905,639284,863004,941700,431489,784597,642198,990169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]