SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391117 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391117 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901022,920723,870680,467436,561028,72399,987215,24529,861486,917777,480162,452462,417398,1036396,723205,494133,975594,381826,657380,682661,994085,667666,591393,491388,388424,816044,790044,903658,851248,698753,240778,994227,880647,281836,516523,554588,473655,340377,760014,62627,1035014,317607,767048,139067,235390,537759,422262,420633,99126,336078,782202,622693,285959,173939,644501,936922,766961,769152,150172,379610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]