SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440514 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440514 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926440,291184,550727,412236,260835,360607,442193,555755,791937,704915,1009400,827831,614145,133328,735861,902058,772703,786488,970378,934389,563128,284426,281138,628493,807984,192396,711688,210499,652139,855929,694621,176124,69004,982777,240530,503143,528200,187878,111475,94986,2432,904150,966546,34607,812310,745120,679690,792866,603352,890352,292380,219979,133909,348429,484186,33668,647703,284987,814505,436552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]