SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581593 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581593 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633926,435133,898705,556797,994411,829006,546078,23875,1012874,536449,737784,747933,127282,385694,122728,869920,1019488,781887,996646,451177,443749,180254,852127,490472,650615,119771,997162,723514,392997,921584,708619,207118,540781,1003769,933420,496658,956023,51155,446286,326798,1011055,1038825,543886,479621,231451,231311,54949,812047,644703,959755,184686,671630,629898,289609,675782,60727,489597,1028395,298267,236201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002921s ]