SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510083 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510083 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426160,789901,344417,23406,734085,874283,174930,918537,166113,15255,779105,10622,991726,766720,275366,653255,942547,287382,200047,783497,2265,819972,781948,125182,584133,349620,69113,310720,968979,14208,323742,380878,665218,1027583,117839,922219,853592,482598,213193,665084,582275,765203,522192,279291,120293,351422,975773,889253,866586,284680,945120,99191,597525,30608,537049,697903,288940,400475,228448,549811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]