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` = 1005334 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005334 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021612,357748,64177,331102,198028,766870,30546,60043,515830,378647,444289,443014,927327,951250,155437,126764,30157,716239,715648,339871,561064,631244,750231,379566,594541,695584,935517,841915,777054,565965,656814,331813,815588,67850,338497,641421,750355,333656,240890,997371,485303,212218,349475,403639,756428,636020,300518,363454,491720,119879,866633,559605,992105,201511,470201,285401,515951,571761,535616,491143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]