SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389909 LIMIT 1 [ RunTime:0.000880s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389909 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988169,223284,31461,1045515,272336,628978,119174,280486,626751,393145,684230,904520,842949,638929,845399,465622,506758,574731,383537,372682,560937,871979,227276,756507,134009,481567,371991,209892,278905,943561,1041283,917365,385795,704240,882920,136139,466269,428931,459022,776288,352448,89154,996015,651765,987704,506335,910112,381943,520792,645501,873236,736726,537499,680120,1026558,52722,879590,744299,48190,721326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001319s ]