SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501744 LIMIT 1 [ RunTime:0.001843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501744 [ RunTime:0.005862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482501,204245,811397,213081,691431,1024570,582751,923053,359986,173948,256435,412167,1021244,458298,498723,557932,736539,377927,452617,340011,76848,89037,836599,613930,994187,200734,959894,911118,709050,393205,692780,1028680,551640,473203,291681,257283,13365,512052,666435,292544,75654,927058,1026732,921589,385314,41263,452564,789374,874248,446720,367683,41406,963040,570240,203824,940840,865117,1014808,424441,784348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501744 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501744 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]