SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531057 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531057 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374969,844881,270459,202559,473566,914158,948971,251177,790950,407269,429648,167518,153450,431503,564971,587380,667842,434106,569007,396860,471116,731076,706334,614055,962696,116442,939426,44234,744831,269042,302632,287541,49648,137992,916756,691017,667761,964678,642101,890231,542945,98049,146391,536349,939428,331264,117520,687368,855366,611978,25160,380917,1007703,572743,936534,626529,397131,582086,912446,154540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]