SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022434 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022434 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780448,191305,697511,104759,754957,164534,467447,567596,797537,948753,777058,965400,223791,246276,363922,566519,957738,952547,566553,966243,421615,930768,604888,942048,218733,760066,414589,922481,64856,335734,422425,7223,888698,819481,198158,424333,160356,238096,614821,161403,472878,152623,519926,16399,822454,472849,342518,450305,320956,854397,825364,349605,407937,673422,451637,475005,426224,633744,309533,659099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]