SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487817 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487817 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398715,814898,890046,587838,459474,38891,205818,531085,369388,841124,750148,323984,1038154,671707,737612,421985,1002257,328355,228609,589764,532592,1023232,715227,1038879,990776,402947,795305,752912,722350,171520,267120,732161,483497,616734,103747,525322,553829,922143,367642,536765,12657,244488,958326,910456,941193,477103,746105,268569,943614,843066,91550,875931,675273,404671,826454,723997,497858,167038,237543,152832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]