SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002876s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412621 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412621 [ RunTime:0.003949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413940,119141,916464,242245,50403,181496,400529,461333,560818,423393,823334,196893,269616,396257,723780,366388,625032,118093,965207,715314,504638,439721,919486,811978,308192,666011,790620,214203,313297,503734,960277,1031914,373142,946941,508697,242937,968904,17076,19285,282347,1035392,606397,259911,297385,527226,887426,604123,75235,257860,388111,999909,706723,626322,582725,1008296,591920,893601,157294,735179,643607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]