SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105816 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105816 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975309,784051,355365,360201,244365,736940,914531,710561,198468,270784,575019,1036896,993371,676397,448002,460155,422298,1026764,1000097,770062,643300,754978,953461,27829,940715,444100,870779,804423,970538,453003,397123,881360,662402,735231,367894,529250,484431,118554,563533,893571,914451,142969,1032678,320298,1005860,677821,167104,758628,986680,527671,403180,199381,1028338,1045580,209693,1005933,617597,273521,202367,1004532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001497s ]