SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534222 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534222 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751845,699653,934432,977258,982077,891422,414883,778857,920547,713559,392541,746943,763113,602985,836866,520086,888034,887112,482396,521524,172047,903915,564489,177825,858294,272206,161688,506009,358825,331534,1906,692798,113212,105800,302220,953194,143692,477173,539427,879132,875244,545276,258880,149501,148027,183754,1003219,130057,581895,1002812,37889,190395,1013195,513050,756135,473817,148761,318740,481793,804518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]