SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465593 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465593 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890518,934539,248702,885184,559050,413808,700919,558500,654700,805845,418700,543354,508562,905738,418469,150710,279551,930223,543146,77965,115089,1015324,740775,451564,500201,144599,819531,343641,404499,507026,19647,88839,982138,840099,862833,564270,678513,228943,914494,563667,365043,1043721,63098,175405,844890,131529,635029,259124,472967,113806,831215,536295,696807,454220,41730,72227,1004436,44571,194246,314338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]