SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032535 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032535 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810470,806628,735502,710402,438272,75156,201203,129217,967768,686129,1020098,442188,555300,832046,773006,411535,221891,612924,689661,34788,352026,1027532,385056,212235,635709,576315,354801,334956,231899,905868,31593,557443,796890,939985,277128,199435,1045841,464551,1024001,895610,610899,1047132,203578,158765,627386,1024433,56727,712712,303910,787740,174048,623429,700466,121988,337223,910724,135182,888575,101660,83715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]