SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 229838 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 229838 [ RunTime:0.001390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822988,844648,1018208,896347,1012593,687142,339891,13738,301196,1034416,473049,774692,1041381,325307,700451,942727,167132,707683,539897,701911,810665,1007044,887291,92066,496681,673615,358471,755491,1018941,884237,6590,186936,182205,1002391,216080,79476,179159,729246,940685,996751,484071,334858,310181,230427,865208,797212,146217,921430,333892,564976,812003,551366,314953,913396,339201,255646,823687,558215,599239,939084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 229838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 229838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]