SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201590 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201590 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394590,328499,880127,965686,544668,771833,143365,585327,1002221,848400,911250,246526,944363,784102,669968,604762,267944,240181,453185,267047,416032,551371,87594,909453,624673,791996,188029,485849,131452,357791,895442,788633,503515,866193,144803,88690,946159,895336,849601,256558,167536,24491,14627,609914,17813,461024,533192,66137,158185,184688,447037,711633,32179,882229,206763,800384,521972,693501,1040409,471170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]