SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55550 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55550 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46012,814773,247420,981473,687025,194617,831876,519905,161766,125419,352014,498660,750860,518347,422637,124110,439178,579996,827137,921233,777638,21453,196585,555447,135878,846111,743291,88663,226206,224884,753220,222990,283833,1046220,790198,273887,39661,768351,586873,246444,580835,961338,208282,972324,285400,879416,797876,612749,924962,873480,547148,126191,215992,629254,712103,812901,904219,616024,618673,84008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]