SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515409 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515409 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166789,518432,58973,643060,228620,40053,735935,604246,889332,634765,159445,936968,824727,907269,656209,117195,653372,368124,361699,200874,41983,467486,328100,483954,630429,134338,141489,282106,162569,267822,249406,277700,307076,305563,574152,692785,55,80355,316156,124652,989665,724686,162918,294403,136032,224886,350666,828029,223364,906407,208948,583988,766494,584500,221154,1008806,597153,732335,552737,819213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]