SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346308 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346308 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988468,606718,530245,153008,455532,882061,137835,963834,353286,170081,428555,517189,702879,659672,757331,928432,733488,386764,323448,809106,834560,384899,1026318,843289,427602,219200,724654,693471,606210,688650,183615,1043905,219612,1047290,246393,228466,1016521,803593,555959,297165,98493,279281,276118,421926,122678,674543,480155,1028201,713798,605901,225037,219236,752404,312349,734751,166493,246026,315003,530021,252870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]