SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4283 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4283 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223724,493302,977021,109131,622421,511375,748843,697015,457087,548229,910467,866786,1001556,14535,271946,449410,353981,931139,37123,849655,763758,780548,201871,1029311,951368,433546,104472,1018718,859310,613520,19803,443081,755093,825300,928340,678832,888522,106763,373835,84822,980548,720246,233496,154445,117317,801063,323749,275653,333945,429353,257500,581595,343217,918379,767391,248299,361120,297461,333604,971624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]