SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 688503 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 688503 [ RunTime:0.002961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186621,898019,242566,1001753,973014,322928,880182,479185,120346,427845,997102,859047,912295,1513,338653,214953,111094,265486,47023,245486,242463,553094,733840,484403,110608,470746,780312,354912,310925,342532,193700,434613,709926,198167,515525,587555,119063,443302,880159,402016,382854,415854,921850,373900,69660,493706,158162,933517,843616,600994,630364,979584,357582,722198,71073,65843,526779,614389,1005138,238795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 688503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 688503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005635s ]