SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178860 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178860 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890361,922950,87831,880466,758838,914192,120222,157071,260133,482754,249285,987376,107144,911752,379218,210720,754924,1001477,419977,628853,511145,836990,95718,460587,991739,257718,264091,800780,693057,37038,701020,731570,436811,651744,121401,101326,988970,355194,215382,894783,406491,288479,263523,203179,621595,835487,952436,656837,899381,289982,808794,646867,913555,219281,699768,510841,577959,863513,458351,110653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]