SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488913 LIMIT 1 [ RunTime:0.002060s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488913 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467865,712501,464972,766791,956938,951920,451159,530543,858783,952104,156968,753372,277202,423547,1042816,498650,921702,183529,515693,369964,304317,852332,787583,928893,416827,191934,401315,812256,15392,19628,367210,126161,314150,691152,582030,32354,66515,354833,565988,227129,597980,756188,989943,260474,739201,133524,495702,607746,913159,126531,198375,561412,1005132,837556,658294,99817,135660,251026,917281,690208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]