SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005409 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005409 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455300,31601,181389,1004731,429911,419648,105710,332755,824578,689624,141239,900969,701909,412017,903448,520672,794763,1019073,215656,435001,153594,664315,441298,26749,297551,1027065,214049,834530,759378,444077,582164,409281,24070,109688,800293,980223,148079,674542,72232,244675,951933,894579,918094,693510,613235,441713,230864,138135,416242,747958,968676,224988,287012,549551,388246,699359,341029,728141,140009,769759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]