SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143811 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143811 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393478,271515,6825,135435,835727,675413,331197,596179,46772,53778,183680,1046150,195468,1019864,785256,725529,200239,678823,52921,49330,690500,766928,63061,1000158,677080,309010,587921,47789,953028,832986,990862,892004,182131,223853,444600,304107,480855,74276,121974,847123,1020380,94028,177938,146416,473175,539768,237090,4599,331029,430434,334385,34446,772821,477824,120083,510081,362015,822327,851554,5764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]