SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300041 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300041 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236613,794915,979490,797925,379324,444011,949333,292002,396530,475267,388556,388567,103457,723896,540526,216105,899540,1018572,193668,902937,280968,734494,442756,921783,50387,155262,267745,378517,1040887,407808,1033971,750712,511604,596103,955784,802134,939001,215817,638050,590927,392205,581320,183644,824401,819651,283724,462578,373301,118313,152879,96934,523389,90574,386335,390887,1031087,941317,622155,784142,5462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]