SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343019 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343019 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414593,26398,53082,806234,960910,177722,884302,819803,807982,145006,898264,291233,639573,724286,1032058,112329,858668,115211,319854,413771,547397,675586,501562,728876,338878,245247,416149,292855,498659,318071,100231,597790,36832,844575,606681,550112,535425,762322,379100,251893,397232,905491,347199,770791,61456,376096,1020749,569116,108779,706242,1004098,429689,375509,1044856,547536,261691,80552,602489,481864,146445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]