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` = 501873 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501873 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437936,1033842,354938,753951,418848,885768,401469,619902,809272,431535,668894,43092,196339,690526,275218,960537,93487,156626,599938,30148,957963,967734,205486,698718,687646,912667,525913,57357,860851,304628,248873,452987,66626,644214,231644,555502,535593,628368,235743,501603,597158,500905,115459,272730,329998,765467,692698,160755,144846,87244,121365,349817,868758,495522,505454,904060,152408,604008,658791,832675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]