SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532111 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532111 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916413,992536,157194,816686,179752,170036,115392,795151,224286,624221,816973,356970,815923,403211,120617,268166,361842,314167,427342,406797,247095,784303,884907,744476,910562,934795,885612,568518,515895,832453,537423,731558,237118,134657,568773,448405,779525,238514,489130,628480,650989,960854,271279,560582,994297,70781,591478,625165,555708,146186,927439,249190,491780,905436,197542,932962,858608,48781,117970,149751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]