SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318801 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318801 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048886,268455,976684,337460,208292,644527,1245,995278,693177,500676,502959,848264,375728,170555,489611,837437,175256,706200,270901,113943,788933,247511,195803,174520,844440,817845,363450,657924,630018,333381,15886,853146,1048780,643229,283578,642299,661671,349104,333253,44924,78848,344353,207395,517416,576242,192244,371568,849028,326724,844079,176589,122921,309638,238919,695233,232569,102530,342133,995417,790455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001657s ]