SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314702 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314702 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16204,114194,177738,670610,85883,334572,492868,167859,778545,411799,141139,199526,517753,89157,895708,1040153,233459,851440,196100,279167,844675,885884,611,138611,501454,1005726,407031,448628,775591,386530,897452,847676,1034323,425160,1032875,301659,783025,204774,651151,387406,1003156,924309,464050,113725,135973,319077,783445,345106,797835,883917,677215,8967,474503,972912,410615,1038621,1026421,892104,904739,456854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]