SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419394 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419394 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999615,681956,79986,224287,854269,448411,843107,451325,419282,373878,306708,68637,477580,709938,456725,441528,335555,877240,536203,165721,34234,41177,409936,293925,288968,705227,995397,762704,968976,976916,698179,285996,788255,861529,1028658,496315,893035,403113,980499,697922,1037394,421198,7971,243458,227574,186025,404593,194478,726423,1010667,375999,361024,190359,1008018,486557,776659,308839,829840,734208,767267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]