SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414419 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414419 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658645,758436,781015,69676,796852,332944,529034,144459,67709,1008297,353889,270811,611045,804139,366243,900275,448338,892584,637115,696387,238142,112452,231198,1021336,920625,470997,514490,332126,755250,975155,896466,363094,317497,172970,812975,428845,561304,750838,204344,504718,163690,166660,863397,49441,805909,823489,871997,427979,410290,520164,801460,141830,438275,1825,223439,1048347,271460,800945,583258,463429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]