SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80728 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80728 [ RunTime:0.002932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420354,108687,146643,663578,40032,122886,179453,165876,776842,333841,581457,466356,379288,700766,408319,237295,824750,74665,270540,924059,984804,938566,875875,883322,212996,210205,783439,751876,747673,659705,647719,479115,625531,672610,994466,915316,778144,149458,666844,213961,983735,208952,5240,59257,261524,974177,398488,412991,789231,160964,295472,1010927,510918,740186,56040,199309,446093,893025,211092,730267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]