SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499811 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499811 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531036,845189,148169,836934,653918,210588,267251,337821,631900,874654,876949,50035,4693,15183,325269,824166,155086,682277,292831,92766,273679,478015,522525,637334,47839,961202,594912,152331,140738,330010,843898,618268,561964,919071,77059,265663,109221,237393,92415,956406,358349,1031672,523788,567290,863976,426192,362252,1040231,319773,651163,243196,170694,717531,996918,612911,563800,748214,636836,193264,234983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]