SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428150 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428150 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299190,382185,298497,403661,614475,697354,443704,963924,767737,934463,276653,181362,101094,66545,746057,1013900,643337,609014,820969,249522,635818,891196,19256,478037,93573,325183,249797,506631,420877,657323,560679,297295,528921,50439,353985,203551,310857,826280,128841,689384,937395,261761,380142,499339,699981,678011,338741,1019466,468762,216330,865618,129102,236541,383158,241752,404705,719014,157843,141295,636237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]