SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285458 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285458 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113752,967200,950824,892825,99639,735274,363165,757369,476327,772043,41947,145439,624024,618500,3353,747003,973749,410218,768590,1022990,72682,558496,745418,331125,198051,654272,15319,852761,842685,46885,804704,99095,954930,377170,596407,359972,339093,180696,603893,83955,1030030,743912,240759,384985,604518,259964,182461,69538,161389,862528,950307,769527,535249,37302,389517,398958,865311,950799,395722,327269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]