SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018878 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018878 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228852,555413,441447,552267,458204,208528,950808,337288,784454,898049,688624,699184,410177,984364,193509,84728,405304,1030469,31205,673106,279197,951379,590864,415783,661561,126942,724338,915450,879921,835022,846975,107988,72942,411736,347827,340858,935413,281191,928717,1032274,519060,958405,87891,116422,707353,664118,884187,597457,514249,570959,99644,898873,579320,101518,592764,844551,32444,40516,379653,739289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001589s ]