SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018476 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018476 [ RunTime:0.003466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391583,336405,686729,643167,620192,146921,978377,534765,929382,979518,43481,780012,820867,134075,384772,158773,779262,823513,641850,138224,718119,753389,47002,803056,500773,177169,151953,232924,619399,318648,850722,735802,4580,335052,423802,131433,909019,828143,931596,379507,442808,357361,741612,782885,190331,390896,352581,781891,513354,769873,86520,168344,809396,856290,403650,798956,1018532,14834,787833,919721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]