SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508019 LIMIT 1 [ RunTime:0.000774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508019 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193471,814279,879403,691815,627688,318935,480246,1033935,139466,55629,989552,580651,809998,776185,133735,527669,537878,529411,179439,810891,876844,357406,261620,595386,12982,305148,478728,626599,242295,134066,524660,762435,37651,268145,1044182,834701,505266,404616,181553,302041,356848,225748,394807,38779,415369,316783,323216,359278,331078,1047783,634617,796028,714713,374376,662411,170336,239058,865015,452230,72432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]