SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152019 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152019 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352864,513314,818943,478576,704148,169415,269262,839043,240884,444854,467126,480134,115965,423803,590354,890354,424099,575454,181590,394061,912516,560658,414024,844525,326441,904078,878445,243096,905617,580409,475329,489591,211504,923182,87269,788809,1029561,314334,450297,909682,713061,333472,910107,894111,890157,43597,142422,589107,212547,637094,793692,188160,107996,692732,938367,570342,722486,116937,869447,444997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]