SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529108 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529108 [ RunTime:0.005059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237568,155335,790853,48502,101101,6974,927790,572468,839789,748398,121760,877527,517138,64008,362943,316672,392908,398955,340783,441221,434739,686449,998552,365912,325019,53168,731690,272501,872044,266562,974273,436994,431584,150922,369645,1003799,1001626,798081,470238,360523,457833,140214,437238,103978,954105,499929,299634,15477,948701,55556,137658,321680,709931,142445,600278,27155,344673,953403,508733,355749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001554s ]