SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503543 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503543 [ RunTime:0.003355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223221,842024,555973,285708,949704,623953,228282,67811,509225,242697,825665,829496,41480,616195,655101,169581,1033361,585919,871900,459791,285126,606101,1018585,35010,247601,367292,643884,1020195,137368,134511,579255,1034953,543014,953517,398587,742401,839534,989962,792472,967557,257375,390153,873005,894427,217589,513845,497166,213847,600827,197309,800558,766874,553116,575353,650890,319249,727699,61684,338320,656753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]