SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559052 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559052 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838152,420331,510979,908824,1040070,600804,805290,1032897,706572,212282,571415,1026447,594730,39090,273410,357255,897363,844154,835017,996889,830809,17357,937683,1403,587860,559036,1033192,109003,725604,493364,613233,326536,548832,90803,738322,707809,447834,63634,1046466,233896,183773,286687,411372,499231,903511,505245,337298,94396,819344,609765,806205,123055,176849,910244,747591,699108,598937,279261,720439,875830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]