SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040491 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040491 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544638,545503,1011546,662727,100570,217110,748181,291137,109940,297529,726370,669140,103566,666664,755995,273007,219508,912404,18925,620144,841825,1013819,8998,190448,818316,743243,667281,927061,1025839,570381,284548,127199,612579,198467,633170,501257,424216,937791,736504,956308,776551,136781,509602,709286,952527,42564,979488,829988,886611,578221,14535,570524,454904,173372,8002,34747,496990,802261,1041182,799421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]