SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 935403 LIMIT 1 [ RunTime:0.002146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 935403 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845704,143933,694874,121074,171343,131793,807959,355618,965330,15691,401729,358772,357080,174088,983366,14216,49029,670346,891138,418364,1014872,138908,324897,935980,822467,868567,329952,763220,486048,378263,346729,742114,235099,206604,861210,418690,560233,309953,44796,797380,896992,936189,160224,229215,385903,738831,913510,141728,808445,173405,40790,993425,390448,594762,831934,978742,206795,122415,980198,397986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 935403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 935403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]