SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107317 LIMIT 1 [ RunTime:0.003075s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107317 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14842,458089,248718,735156,890487,352432,358207,1026004,702253,147185,671013,704020,97021,892944,143404,169811,844424,349375,121596,194660,195949,26651,79507,384678,611829,76083,532829,691009,868271,330754,962903,1001788,484422,1702,103235,1013306,160009,207910,110725,766761,457995,901938,744014,921701,761599,61432,164036,809154,880566,346342,641097,974552,686605,931781,3728,1003829,155270,949418,399800,632044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005129s ]