SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023396 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023396 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397571,804343,494812,669022,365487,520125,316448,162847,174456,235712,483703,168177,993192,908795,224673,703361,1005625,753693,346726,1042558,875292,893480,25768,4085,987875,976608,32304,338347,222724,734795,315146,850485,912696,624626,87780,960692,624885,213136,379700,648267,810184,286711,673668,366027,995002,952637,528022,344454,140421,133941,645026,472760,877413,816518,574321,638214,577086,919836,942233,366944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]