SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354750 LIMIT 1 [ RunTime:0.003960s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354750 [ RunTime:0.002905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362868,768087,377653,742360,1009083,228994,644257,500426,119531,638187,953130,748456,208168,699490,879735,450887,831697,413211,989470,99870,1037544,134551,403361,842830,151942,143236,254070,409173,861385,380400,56008,686449,249557,783415,937416,485179,367418,217779,618395,207312,399702,383926,485424,42272,301709,386553,845660,814035,606172,953826,570961,616622,895592,741691,1008259,118370,749232,856628,848016,747799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]