SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502366 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502366 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216221,518693,639683,446955,242715,155556,935415,1024948,361090,784870,505645,627895,237444,810097,863664,843701,901922,14668,869459,953660,930688,884868,546796,184054,144281,66132,611872,533839,771541,944327,581325,888957,140007,212281,510893,507874,160425,6311,806631,495416,749372,221422,939016,254615,116601,148394,475226,404446,586575,26182,649668,350511,341374,899787,197367,935611,455978,658868,682983,6385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]