SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004331 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004331 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321625,906521,447251,507449,420162,330765,909207,819090,476872,1047693,222897,805320,247836,618806,431753,712939,915532,839726,528638,895125,35094,171115,816181,141608,707539,192169,652072,639761,351029,1042001,776817,45286,142374,598506,764028,761623,488861,411749,87556,893362,646222,1033218,766092,139909,454103,777441,602671,675990,173981,118911,959182,993928,760191,1009194,900357,892721,420366,282694,367766,810256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]