SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498980 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498980 [ RunTime:0.004286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495236,343090,866862,980428,356920,536294,1022075,438761,319394,459137,393116,140833,747992,789822,271533,52178,529066,476281,818290,333265,827752,203941,991761,580163,914208,913301,903464,318375,353930,567344,423483,401395,42484,228482,940291,192481,995429,965598,897523,397484,142396,16370,1025710,591419,394909,214761,572360,918727,663564,555427,160121,264658,521972,506245,186384,814030,296430,715165,977533,263967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001704s ]