SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041703 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041703 [ RunTime:0.007936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132756,806956,183519,28119,254701,773702,997972,25441,597206,101913,591614,592548,629571,180594,386975,101066,399068,193323,789629,73749,906628,1028892,32232,999330,333586,164140,103941,396598,1006973,911567,634570,994064,234053,113759,795223,827091,582024,469107,10068,316765,558467,646776,368604,722018,98792,511794,315242,449178,233910,591081,1024583,279412,750594,1034416,368175,394109,342251,552444,906523,100971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]